1. Which of
the following is true about PowerPivot?
(Select all
correct answers)
a. PowerPivot is part of Microsoft Excel 2013.
b. The PowerPivot is an Add-in that must be enabled.
c. After you enable PowerPivot it will be available every time you begin Microsoft Excel.
Tip: Advanced Excel, page 282, 283
2. In Microsoft Excel, you can Get External Data from which of the following sources?
(Select all
correct answers)
a. Microsoft Access
b. From the Web
c. From Text
Tip: Advanced Excel, 293
3. When you Import Data into Excel you can choose several options. Which ones are available?
(Select all
correct answers)
a. PivotChart
b. Table
c. PivotTable Report
Tip: Advanced Excel, page 295
4. A PowerPivot uses a Data Model.
a. True
b. False
Tip: Advanced Excel, page 298
5. If the Data Model has been updated, Power View will notify the user that the Data Model has changed. Users can apply the changes.
a. True
b. False
Tip: Advanced Excel, page 325
